﻿CREATE VIEW [dbo].[TempArticleSalesStoresAverage]
	AS 
	SELECT StoreName, 
			Date, 
			AVG(Sales) Sales, 
			AVG(GM) Margin
			FROM TempArticleSales s
			GROUP BY StoreName, Date